data warehouse
SYSTEM USED FOR REPORTING AND DATA ANALYSIS, AS A CORE COMPONENT OF BUSINESS INTELLIGENCE
Data Warehouse; Data warehousing; Datawarehouse; Data Warehousing; Datawarehousing; Information warehouse; Data warehouses; DataWarehouse; Data Warehouses; Dimensional database; Data warehouse architectures; Fact (data warehouse); Dataware Housing; Fact Data Warehousing; Integration warehouse; Electronic data processing datawarehouse; Enterprise data warehouse; Enterprise Data Warehouse; History of data warehousing; Data warehouse design
<
database> (Or corporate
data warehouse, CDW) Any system for
storing, retrieving and managing large amounts of
data.
Data
warehouse software often includes sophisticated
compression
and
hashing techniques for fast searches, as well as
advanced filtering. A
data warehouse is often a {relational
database} containing a recent snapshot of corporate
data and
optimised for searching. Planners and researchers can use
this database without worrying about slowing down day-to-day
operations of the production database. The latter can be
optimised for transaction processing (inserts and updates).
Compare
data mart.
(2007-05-16)